UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0vgfyKIw0HfB/V3W+EzzPTSbKd0nmLPLPSpo0g8348o='
WHERE
key_id = 'ef03ad09a303b368c28f92bab28ab5d4eba048ec556e1ab58e4c9c11aaf8828e'
AND (
token = '0vgfyKIw0HfB/V3W+EzzPTSbKd0nmLPLPSpo0g8348o='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)