UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zSU23Q2rXwsWcym2Ms+rJBbb02klKyMBQq0daLAjWsA='
WHERE
key_id = '711c2d11db5cb3bacde29974694694f20a8102a25e6067657bc2298be4c96fc9'
AND (
token = 'zSU23Q2rXwsWcym2Ms+rJBbb02klKyMBQq0daLAjWsA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)