UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'RNdSZhkGaJL/Pg94NA0mWopnIHg1D3BLNac21Ctr0w4='
WHERE
key_id = 'ecc1178e55c194c50bc744538f048ac4640d2fb2f9aceda8de21cf099738d95f'
AND (
token = 'RNdSZhkGaJL/Pg94NA0mWopnIHg1D3BLNac21Ctr0w4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)