UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'J6DbNwFDIkAE04h53WAjG14B9CFkc63xnrVtO9gzBQE='
WHERE
key_id = '391b2c4630658d894c299421d1ae247d2d27a344968abee2397fc27e034bbb07'
AND (
token = 'J6DbNwFDIkAE04h53WAjG14B9CFkc63xnrVtO9gzBQE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)