UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'TCdBPmDxnGEAoLlfCxqycKjgM3znoSF5rJBtu6wUrPg='
WHERE
key_id = '03eb8fe2952d4d0ee1dbb2a039445bb3eda802076506c132c1c03c1e51db7b60'
AND (
token = 'TCdBPmDxnGEAoLlfCxqycKjgM3znoSF5rJBtu6wUrPg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)