UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'AYc4kd5a9KFPjyZLqMrLYroL2tzlRYQyu3G6OKBWOCc='
WHERE
key_id = '39800b18b529aa494cab65e7f5f49b5ade3136bc267f95dea678e07957f822c4'
AND (
token = 'AYc4kd5a9KFPjyZLqMrLYroL2tzlRYQyu3G6OKBWOCc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)