UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pXH0/ceBypoNoNLXP1dZDMWxOaseijo5lvnXNnGxuRk='
WHERE
key_id = 'a0eed146dd8e6cba2f785ade5edb57acd56431de4a63fc5cad74d18f29b7e5c0'
AND (
token = 'pXH0/ceBypoNoNLXP1dZDMWxOaseijo5lvnXNnGxuRk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)