UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pI8thGQZ453RPIlEj8tz9khusCdAbjtxPM0m0PBC9Es='
WHERE
key_id = '7527241fcd58dbb8c5f64b6d8cd7fc97474df730999f4f1a7d527a5aeb4c47f8'
AND (
token = 'pI8thGQZ453RPIlEj8tz9khusCdAbjtxPM0m0PBC9Es='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)