UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1GUsUJ3nPKUZzl5j+6pMjQfe7rhrAU1mLco1JhmP/P8='
WHERE
key_id = '8efb1c51c921d55bd6607bd76fbba656fea93688c8975677119c9be5f46e0054'
AND (
token = '1GUsUJ3nPKUZzl5j+6pMjQfe7rhrAU1mLco1JhmP/P8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)