UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'VP5rjwtcWOsM25eAVsw7jYFkdgknrcV3vxf+gphA2yI='
WHERE
key_id = '7572e48e9b04135e175e6c823508b553b4d712789904af40c1d4204263f5d8ce'
AND (
token = 'VP5rjwtcWOsM25eAVsw7jYFkdgknrcV3vxf+gphA2yI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)