UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5xEcNC987NbqH5uffNpjvBVil09vHl+BnnJhxB0iG9k='
WHERE
key_id = 'e23469be3159eb96d1abc5f1b7df6ae63794a3007e0a46ef3384dc6f025f2396'
AND (
token = '5xEcNC987NbqH5uffNpjvBVil09vHl+BnnJhxB0iG9k='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)