UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'o3WCpBU5CY46nNDbuCAf4wC31mxzVx27nVuAJfKh31Q='
WHERE
key_id = '6dccaf4c43062f42c00c4ffc53b6e52deb9d97117a35e6649225e70f7c73714a'
AND (
token = 'o3WCpBU5CY46nNDbuCAf4wC31mxzVx27nVuAJfKh31Q='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)