UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qiClPrwYq4mP3x6G2kirGW/+klsFYjKtyx9rq4hoy+o='
WHERE
key_id = '9bf258dd66c169bc097a57e782a89009afa0047510ce3b88cacb8625105f9992'
AND (
token = 'qiClPrwYq4mP3x6G2kirGW/+klsFYjKtyx9rq4hoy+o='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)