UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'V4n+S+AEV4WglKtaB6iRB1PmNSfdRdmBgvvRcb0Kfq4='
WHERE
key_id = '31f46179d527248881f34af40a0728d195d36aaf5f42bc3a5e70230af4197806'
AND (
token = 'V4n+S+AEV4WglKtaB6iRB1PmNSfdRdmBgvvRcb0Kfq4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)