UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3weIy4ABk6wdo5BK5kWKIjMvcWy+Fe7cuVayBZjKASg='
WHERE
key_id = '1c92cd192ca828684c5b9de2e19ae025596b052a5aa419b592d7220fd66c7cac'
AND (
token = '3weIy4ABk6wdo5BK5kWKIjMvcWy+Fe7cuVayBZjKASg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)