UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'tQ9DjBT695GpOt61dx5fcyybbB5wHFcHO9nR5J3tOt0='
WHERE
key_id = 'bc1e8d753869dd93535cedf0cab4acbb0abedb2a4985f5750d81c387f14ce074'
AND (
token = 'tQ9DjBT695GpOt61dx5fcyybbB5wHFcHO9nR5J3tOt0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)