UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Hu+6zpl5Naj3RS1r4VjO7B3aEpZQKIN143Bg6tywkwA='
WHERE
key_id = 'a75bf3332f3e09efb57c309eac40f97a236ee14e74fdac7ce5888cc609238813'
AND (
token = 'Hu+6zpl5Naj3RS1r4VjO7B3aEpZQKIN143Bg6tywkwA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)