UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '+aoKGcWBGSNC+mQb4o0eylc2INKqgiJycEonpziIGSU='
WHERE
key_id = '31aec56c2b6fd586a183d5741a6c75d5fdf67f2cf9237061749c542aac208fcf'
AND (
token = '+aoKGcWBGSNC+mQb4o0eylc2INKqgiJycEonpziIGSU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)