UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '+q63zd86E9l/7aqP67hiDCXjvnnKbQlzv1lvDQ/KkBw='
WHERE
key_id = '8963e132c4cf100de733e320834e443579c4061b2e18c00f671e9320fae62ae0'
AND (
token = '+q63zd86E9l/7aqP67hiDCXjvnnKbQlzv1lvDQ/KkBw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)