UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZkzBIKkIw0k1yMs08xXGQ04vgOnP5YIVrLEc1fPszUg='
WHERE
key_id = 'bf9b009e085107972e9dd3cff327f022dee591565277b7087060dee5f29d6d27'
AND (
token = 'ZkzBIKkIw0k1yMs08xXGQ04vgOnP5YIVrLEc1fPszUg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)