UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pGtA0KtHsG98V0ihBLKqPjVGi6wgJI43nu9k5YVzsqI='
WHERE
key_id = 'a67dd91291f374f2a5caecc15c0f2039a7ec9bc8a85cca9269573d00c5392ae2'
AND (
token = 'pGtA0KtHsG98V0ihBLKqPjVGi6wgJI43nu9k5YVzsqI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)