UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'tVzFmfQ/hCV4OLHjTXnmtKfw4NE7DHQdwd5Yx9UQfYo='
WHERE
key_id = 'b8056bd012eed616d8152c6326617e3c34f66c37cfd6309f89f12e35627cd02c'
AND (
token = 'tVzFmfQ/hCV4OLHjTXnmtKfw4NE7DHQdwd5Yx9UQfYo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)