UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HECdhdTH3/+T7mrHKJhOYJDiEl8GyEafpDOyhnLQ4mg='
WHERE
key_id = 'f47947a8bc8eda71fa90305d5a5451e5c36e2925d1c97ef4f9f59f37ad2db1a4'
AND (
token = 'HECdhdTH3/+T7mrHKJhOYJDiEl8GyEafpDOyhnLQ4mg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)