UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'OCMEqYLjbhgRqFhw6Bpd1mJW7j/ccBIaJPJRJCX4Fv4='
WHERE
key_id = 'bea3d0d3065c073423d663b842b0ae34e7047558e6b7e2ea431df96a72ee767f'
AND (
token = 'OCMEqYLjbhgRqFhw6Bpd1mJW7j/ccBIaJPJRJCX4Fv4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)