UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'mBQE8ZjdYuEaMwCe2ww9+yK+YjtwblnCAiMS8HUQ3/k='
WHERE
key_id = '9dae01e26572fc60c957f48c7fff49fec49a4b58613f132c8b70902958bce9be'
AND (
token = 'mBQE8ZjdYuEaMwCe2ww9+yK+YjtwblnCAiMS8HUQ3/k='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)