UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'CDKQpOqslOSu3g3XhAvCXy3m1d2L+/+p7U6mkzY7Ayk='
WHERE
key_id = '26efc562954764e6dc885f965f65e6a46b6f424161101d9e7e8c009f4685f440'
AND (
token = 'CDKQpOqslOSu3g3XhAvCXy3m1d2L+/+p7U6mkzY7Ayk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)