UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'NUQ3KhbuNs56Ne7i5XWoOT5JpB/8Oh8if7Yocuru+KA='
WHERE
key_id = '0e4ba5c1037c021b37c096f3da9e7a5d08f820964997d91b09a74d726afbdbb9'
AND (
token = 'NUQ3KhbuNs56Ne7i5XWoOT5JpB/8Oh8if7Yocuru+KA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)