UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'KAVL7xU9DMld3apFNa7UEn/i64yDywxLFXkcoTY3D+I='
WHERE
key_id = 'a10012ae8f74c10b2e4b9d583157800d26fb74b2fdcd5f95372e1037787c3fb6'
AND (
token = 'KAVL7xU9DMld3apFNa7UEn/i64yDywxLFXkcoTY3D+I='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)