UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9lvnamm1iZCQ42Baqdc9hEGVlFyLR18S/UZWvBmksII='
WHERE
key_id = '178e0ba976f0ba6fda376a13e8e74558ef7cb2d928a28ed026c03a641a54a03e'
AND (
token = '9lvnamm1iZCQ42Baqdc9hEGVlFyLR18S/UZWvBmksII='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)