UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'R8udI9MGo1Z66RjYb/WpCKogxIEtXaliP36MwdSzWLg='
WHERE
key_id = 'dfc1989aa615d8cd5e4dc1ed66fcba50b96ca89f3e0faafa8a71e176da167b71'
AND (
token = 'R8udI9MGo1Z66RjYb/WpCKogxIEtXaliP36MwdSzWLg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)