UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BG7yOq66xtWV0oMmPXvRVdnH6i20ELVQyYm2s4sBV80='
WHERE
key_id = '92a62363e721a87568b88c2674cc64cc69faa12a01cec62eb7c28757d6b0de60'
AND (
token = 'BG7yOq66xtWV0oMmPXvRVdnH6i20ELVQyYm2s4sBV80='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)