UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'yYquZvPeziOOjzDIJRDd1I/0ohIB3O/zIFiHtGK8cTU='
WHERE
key_id = '71672a89587381332cff306148be1ff703958ebd8fbba0a918c5fb5a7744de54'
AND (
token = 'yYquZvPeziOOjzDIJRDd1I/0ohIB3O/zIFiHtGK8cTU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)