UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'VD3YEc52bi4kL8mkvAYAcC/fNeeXYYh5qZB1/4hxasM='
WHERE
key_id = '08c0da84a7c8480b24da023f49938790bfc7d42c604728ef667aad00add8fcc8'
AND (
token = 'VD3YEc52bi4kL8mkvAYAcC/fNeeXYYh5qZB1/4hxasM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)