UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZGMd4gmSWUfiHAkHQ1vnDDuXGQ8Ro8V67w8epldbX50='
WHERE
key_id = 'cbac77bcff0b81c8d73e9117c19ea9056c4e2741106744a5319ff48e7386457b'
AND (
token = 'ZGMd4gmSWUfiHAkHQ1vnDDuXGQ8Ro8V67w8epldbX50='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)