UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'z6x52AtV77A6mYC8ns7ye3K+AXYgYXpsA5CvhG/uzjI='
WHERE
key_id = 'bade91a8f5936216594d89cf5ab27e40275820f8b1ebe478d89fb43378fb0667'
AND (
token = 'z6x52AtV77A6mYC8ns7ye3K+AXYgYXpsA5CvhG/uzjI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)