UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '12AKQ8SyJdnz4nl+vSAnvjq0XXeS8SJ2VixyfL4hwUQ='
WHERE
key_id = 'dd54fa7a4745e335ac600798bdb23b003da645b55792c25693ff1e419d965203'
AND (
token = '12AKQ8SyJdnz4nl+vSAnvjq0XXeS8SJ2VixyfL4hwUQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)