UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HncL3EVHlpDdsAVpCAaL7Z3yXFJwAp2CRctw4+m8MuA='
WHERE
key_id = '62e3824e09735afc1d6961331d4437e9f676b54223568329110346efcc9f60ec'
AND (
token = 'HncL3EVHlpDdsAVpCAaL7Z3yXFJwAp2CRctw4+m8MuA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)