UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ly/PN75zFvBa7jmPD5CkLZ3VErpZZU1mWClP4E88qBU='
WHERE
key_id = '27bfb3efd03e7c0b4668ddfeee00a0204474e3ce0c4cd8c1e0a2801ea47bf171'
AND (
token = 'ly/PN75zFvBa7jmPD5CkLZ3VErpZZU1mWClP4E88qBU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)