UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'NIGuOd9GuQ+W5HZJUskF1s7kZzwvZe9wGkKe9O5zi10='
WHERE
key_id = 'cae5187bbb96345114131e4fdfb8836cde49484db580ed944117dfdf664e7a1a'
AND (
token = 'NIGuOd9GuQ+W5HZJUskF1s7kZzwvZe9wGkKe9O5zi10='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)