UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'i/E/JR8CGhLbj3aT69oAB1ahBTstqbJOWg7Od+6ovgg='
WHERE
key_id = '7e67998025252220e02acc60b4326982dff06104800a371854bfb1380cbee013'
AND (
token = 'i/E/JR8CGhLbj3aT69oAB1ahBTstqbJOWg7Od+6ovgg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)