UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6XO+Ye8yxXRyqB43COCQkkJes/FQeKhN4HugfQ7NSGM='
WHERE
key_id = '4dbe478ce9dc5acbe21ce75728206f1e7f01abaf095f84fa056790d3c7bd0cea'
AND (
token = '6XO+Ye8yxXRyqB43COCQkkJes/FQeKhN4HugfQ7NSGM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)